[dbo].[BAEImisCCAuthAcctGetByCashAccount]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisCCAuthAcctGetByCashAccount

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@CAC	varchar(10)	10

SQL Script

create procedure [dbo].[BAEImisCCAuthAcctGetByCashAccount] @CAC varchar(10) as
SELECT *
    FROM CCAuthAcct
    WHERE CCAuthAcctCode = (
        SELECT CCAuthAcctCode
        FROM Cash_Accounts
        WHERE CASH_ACCOUNT_CODE = @CAC)

GO

Uses

[dbo].[Cash_Accounts]
[dbo].[CCAuthAcct]
dbo